/*
 Navicat Premium Data Transfer

 Source Server         : java
 Source Server Type    : MySQL
 Source Server Version : 80029
 Source Host           : localhost:3306
 Source Schema         : ddn1229

 Target Server Type    : MySQL
 Target Server Version : 80029
 File Encoding         : 65001

 Date: 29/12/2022 21:19:28
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for dept
-- ----------------------------
DROP TABLE IF EXISTS `dept`;
CREATE TABLE `dept` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '序号',
  `name` varchar(255) DEFAULT NULL COMMENT '部门名称;部门名1服务2行政3后勤',
  `manager` int DEFAULT NULL COMMENT '经理;员工id',
  `status` int DEFAULT '1' COMMENT '状态;1未删除2删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='部门表';

-- ----------------------------
-- Records of dept
-- ----------------------------
BEGIN;
INSERT INTO `dept` (`id`, `name`, `manager`, `status`) VALUES (1, '服务部', 1, 1);
INSERT INTO `dept` (`id`, `name`, `manager`, `status`) VALUES (2, '行政部', 2, 1);
INSERT INTO `dept` (`id`, `name`, `manager`, `status`) VALUES (3, '后勤部', 3, 1);
COMMIT;

-- ----------------------------
-- Table structure for employee
-- ----------------------------
DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '序号;序号',
  `name` varchar(255) NOT NULL COMMENT '姓名;员工姓名',
  `sex` int DEFAULT NULL COMMENT '性别;员工性别1男2女',
  `phone` varchar(255) DEFAULT NULL COMMENT '手机号;手机号',
  `id_num` varchar(255) DEFAULT NULL COMMENT '身份证号;身份证号',
  `hiredate` datetime DEFAULT NULL COMMENT '入职时间;入职时间',
  `station_id` int DEFAULT NULL COMMENT '岗位id;岗位1前台2保洁3保安4服务员5经理',
  `dept_id` int DEFAULT NULL COMMENT '部门id;所属部门1服务部2行政3后勤',
  `salary` decimal(24,2) DEFAULT NULL COMMENT '工资;工资',
  `status` int DEFAULT '1' COMMENT '工作状态;工作状态1在职2休假3离职',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='员工表';

-- ----------------------------
-- Records of employee
-- ----------------------------
BEGIN;
INSERT INTO `employee` (`id`, `name`, `sex`, `phone`, `id_num`, `hiredate`, `station_id`, `dept_id`, `salary`, `status`) VALUES (1, '侯海燕', 2, '15277536311', '420101198101010977', '2019-12-29 20:23:18', 5, 1, 12000.00, 1);
INSERT INTO `employee` (`id`, `name`, `sex`, `phone`, `id_num`, `hiredate`, `station_id`, `dept_id`, `salary`, `status`) VALUES (2, '萧磊', 1, '17727424875', '420101198101013123', '2018-01-01 00:00:00', 5, 2, 11220.00, 1);
INSERT INTO `employee` (`id`, `name`, `sex`, `phone`, `id_num`, `hiredate`, `station_id`, `dept_id`, `salary`, `status`) VALUES (3, '程丹丹', 2, '15233836125', '420101198101017001', '2021-12-29 20:25:43', 5, 3, 10000.00, 1);
INSERT INTO `employee` (`id`, `name`, `sex`, `phone`, `id_num`, `hiredate`, `station_id`, `dept_id`, `salary`, `status`) VALUES (4, '谢敏', 2, '17198637851', '420101198101017191', '2019-12-29 20:26:39', 2, 1, 5000.00, 1);
INSERT INTO `employee` (`id`, `name`, `sex`, `phone`, `id_num`, `hiredate`, `station_id`, `dept_id`, `salary`, `status`) VALUES (5, '谢英', 2, '14263637219', '420101198101016113', '1988-05-15 00:00:00', 1, 2, 4000.00, 1);
INSERT INTO `employee` (`id`, `name`, `sex`, `phone`, `id_num`, `hiredate`, `station_id`, `dept_id`, `salary`, `status`) VALUES (6, '邓浩', 1, '14368641214', '420101198101014468', '1992-06-04 00:00:00', 3, 3, 5500.00, 1);
INSERT INTO `employee` (`id`, `name`, `sex`, `phone`, `id_num`, `hiredate`, `station_id`, `dept_id`, `salary`, `status`) VALUES (7, '梁秀兰', 2, '18281837244', '420101198101016594', '2015-01-15 00:00:00', 4, 1, 4500.00, 1);
INSERT INTO `employee` (`id`, `name`, `sex`, `phone`, `id_num`, `hiredate`, `station_id`, `dept_id`, `salary`, `status`) VALUES (8, '贾斌', 1, '16816121715', '420101198101019592', '2003-09-23 00:00:00', 3, 2, 5500.00, 1);
INSERT INTO `employee` (`id`, `name`, `sex`, `phone`, `id_num`, `hiredate`, `station_id`, `dept_id`, `salary`, `status`) VALUES (9, '曹丽丽', 2, '16914377481', '420101198101010344', '1988-04-25 00:00:00', 4, 3, 5000.00, 1);
INSERT INTO `employee` (`id`, `name`, `sex`, `phone`, `id_num`, `hiredate`, `station_id`, `dept_id`, `salary`, `status`) VALUES (10, '孙阳', 1, '14879521844', '420101198101011873', '1979-09-22 00:00:00', 2, 1, 4500.00, 1);
INSERT INTO `employee` (`id`, `name`, `sex`, `phone`, `id_num`, `hiredate`, `station_id`, `dept_id`, `salary`, `status`) VALUES (11, '邱莉', 2, '17191457574', '420101198101016922', '2017-12-11 00:00:00', 4, 1, 4350.00, 1);
COMMIT;

-- ----------------------------
-- Table structure for examine
-- ----------------------------
DROP TABLE IF EXISTS `examine`;
CREATE TABLE `examine` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `empl_id` int DEFAULT NULL COMMENT '员工id;员工id',
  `days_late` int DEFAULT NULL COMMENT '迟到;迟到次数',
  `leave_early` int DEFAULT NULL COMMENT '早退;早退次数',
  `absent` int DEFAULT NULL COMMENT '旷工;旷工次数',
  `reward` varchar(255) DEFAULT NULL COMMENT '奖励;奖励内容，字符串',
  `status` int DEFAULT '1' COMMENT '状态;1未删除2删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='绩效考核';

-- ----------------------------
-- Records of examine
-- ----------------------------
BEGIN;
INSERT INTO `examine` (`id`, `empl_id`, `days_late`, `leave_early`, `absent`, `reward`, `status`) VALUES (1, 1, NULL, NULL, NULL, NULL, 2);
INSERT INTO `examine` (`id`, `empl_id`, `days_late`, `leave_early`, `absent`, `reward`, `status`) VALUES (2, 2, NULL, NULL, NULL, NULL, 2);
INSERT INTO `examine` (`id`, `empl_id`, `days_late`, `leave_early`, `absent`, `reward`, `status`) VALUES (3, 3, NULL, NULL, NULL, NULL, 2);
INSERT INTO `examine` (`id`, `empl_id`, `days_late`, `leave_early`, `absent`, `reward`, `status`) VALUES (4, 4, 1, NULL, NULL, NULL, 1);
INSERT INTO `examine` (`id`, `empl_id`, `days_late`, `leave_early`, `absent`, `reward`, `status`) VALUES (5, 5, 3, NULL, NULL, NULL, 1);
INSERT INTO `examine` (`id`, `empl_id`, `days_late`, `leave_early`, `absent`, `reward`, `status`) VALUES (6, 6, NULL, 1, NULL, NULL, 1);
INSERT INTO `examine` (`id`, `empl_id`, `days_late`, `leave_early`, `absent`, `reward`, `status`) VALUES (7, 7, NULL, NULL, NULL, NULL, 2);
COMMIT;

-- ----------------------------
-- Table structure for perf
-- ----------------------------
DROP TABLE IF EXISTS `perf`;
CREATE TABLE `perf` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '序号',
  `empl_id` int DEFAULT NULL COMMENT '员工id;员工id',
  `month` decimal(24,2) DEFAULT NULL COMMENT '月度绩效;月度绩效',
  `year` decimal(24,2) DEFAULT NULL COMMENT '年度绩效;年度绩效',
  `grade` decimal(24,2) DEFAULT NULL COMMENT '绩效值;总绩效',
  `status` int DEFAULT NULL COMMENT '状态;1未删除2删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='绩效统计';

-- ----------------------------
-- Records of perf
-- ----------------------------
BEGIN;
INSERT INTO `perf` (`id`, `empl_id`, `month`, `year`, `grade`, `status`) VALUES (1, 1, 1.00, 1.00, 1.10, 1);
INSERT INTO `perf` (`id`, `empl_id`, `month`, `year`, `grade`, `status`) VALUES (2, 2, 1.00, 1.00, 1.10, 1);
INSERT INTO `perf` (`id`, `empl_id`, `month`, `year`, `grade`, `status`) VALUES (3, 3, 1.00, 1.00, 1.10, 1);
INSERT INTO `perf` (`id`, `empl_id`, `month`, `year`, `grade`, `status`) VALUES (4, 4, 1.00, 1.00, 1.10, 1);
INSERT INTO `perf` (`id`, `empl_id`, `month`, `year`, `grade`, `status`) VALUES (5, 5, 1.00, 1.00, 1.10, 1);
COMMIT;

-- ----------------------------
-- Table structure for station
-- ----------------------------
DROP TABLE IF EXISTS `station`;
CREATE TABLE `station` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '序号',
  `name` varchar(255) DEFAULT NULL COMMENT '岗位名',
  `dept` int DEFAULT NULL COMMENT '部门id;1前台2保洁3保安4服务员',
  `status` int DEFAULT '1' COMMENT '状态;1未删除2删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='岗位';

-- ----------------------------
-- Records of station
-- ----------------------------
BEGIN;
INSERT INTO `station` (`id`, `name`, `dept`, `status`) VALUES (1, '前台', 2, 1);
INSERT INTO `station` (`id`, `name`, `dept`, `status`) VALUES (2, '保洁', 1, 1);
INSERT INTO `station` (`id`, `name`, `dept`, `status`) VALUES (3, '保安', 3, 1);
INSERT INTO `station` (`id`, `name`, `dept`, `status`) VALUES (4, '服务员', 1, 1);
INSERT INTO `station` (`id`, `name`, `dept`, `status`) VALUES (5, '经理', NULL, 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
